2020国产情侣在线视频播放_99久久精品自慰喷水_男人的天堂AV网站_精品久久久久中文字幕加勒比

 
技術(shù)博客INFO
聯(lián)系我們CONTACT

公司地址：茂名市人民南路新村大院22號(hào)101

電話：13592986386

MSSQL無(wú)法刪除維護(hù)計(jì)劃您當(dāng)前的位置：首頁(yè) > MSSQL無(wú)法刪除維護(hù)計(jì)劃

MSSQL無(wú)法刪除維護(hù)計(jì)劃

發(fā)布時(shí)間：2020/2/8 17:25:42

use [msdb]

declare @job_name varchar(100)
set @job_name = N'5S.Subplan_1'
--注：jobName為維護(hù)計(jì)劃對(duì)應(yīng)的jobName
--刪除在計(jì)劃里面的日志
delete sysmaintplan_log from sysmaintplan_subplans as subplans
inner join sysjobs_view as syjobs on subplans.job_id = syjobs.job_id
inner join sysmaintplan_log on subplans.subplan_id =sysmaintplan_log.subplan_id
where (syjobs.name = @job_name)
--刪除代理的作業(yè)
delete sysjobschedules from sysjobs_view v
inner join sysjobschedules o on v.job_id=o.job_id where v.name=@job_name
--刪除子計(jì)劃
delete sysmaintplan_subplans from sysmaintplan_subplans as subplans
inner join sysjobs_view as syjobs on subplans.job_id = syjobs.job_id
where (syjobs.name = @job_name)
--刪除作業(yè)